<?php
if(!isset($_SESSION)) 
{ 
	session_start(); 
}
include '../../operations/connection.php';	

$lang = $_SESSION['lang'];
if (empty($lang) || $lang == "EN") {
	$value = "../../value/value_en.php";
} else if($lang == "VN") {
	$value = "../../value/value_vn.php";
}
else {
	$value = "../../value/value_kr.php";
}
include($value);

$list=$_SESSION['sort'];
$page=$_GET['page'];
$str=$_GET['str'];
$_SESSION['sortn']=$str;
$co=$_GET['co'];
$rows_per_page = $_SESSION['rows_page'] ;
$page_start = ( $page - 1 ) * $rows_per_page; 
$page_end = $page * $rows_per_page;
$id_employee=$_SESSION['IDEmployee'];

if($co==1){
	if($list[$str]=="DESC")
		$list[$str]="ASC";
	else
		$list[$str]="DESC";
}

$sql="SELECT a.IDGroupApprove,a.SumMoney,a.IDApproveDoc,e.FullName,a.Tile,DATE_FORMAT(a.Timecreate, '%Y-%m-%d') as Timecreate,a.IDTypeDoc,DATE_FORMAT(b.DateApprove, '%Y-%m-%d') as DateApprove 
				FROM approvedoc a INNER JOIN listapprove b ON a.IDGroupApprove = b.IDGroupApprove
				INNER JOIN employee e ON a.IDEmployee = e.IDEmployee
				WHERE CONVERT(b.IDEmployee USING UTF8) = CONVERT('$id_employee'  USING UTF8)
				AND CONVERT(a.IDTypeDoc USING UTF8)   != 11
				AND CONVERT(a.IDStatus USING UTF8) = 3 AND CONVERT(b.IDLabel USING UTF8) < 1
				AND CONVERT(b.IDStatus USING UTF8) = 3 ORDER BY ".$str." ".$list[$str];

$query  = mysql_query($sql);
$number_of_page = ceil ( mysql_num_rows( $query ) / $rows_per_page ); 

$_SESSION['sort']=$list;
?>
	<table class="tcontent" cellpadding="5" cellspacing="0">
        <tr class="trtit">
        	<td width="10px"><input type="checkbox" name="chonhet" id="chonhet" onclick="clickChonHet(this);"/></td>
        	<td width="10px" ><?=$l_no?></td>
            <td width="20%"><?=$l_document_form?></td>
            <td ><a style="cursor:pointer;" onclick="sort(<?=$page?>,'a.Tile','1')"><?=$l_title?></a></td>
			<td width="15%" ><a style="cursor:pointer;" onclick="sort(<?=$page?>,'e.FullName','1')"><?=$l_writer?></a></td>
			<td width="15%" ><a style="cursor:pointer;" onclick="sort(<?=$page?>,'a.Timecreate','1')"><?=$l_created_date?></a></td>
			<td width="15%" ><a style="cursor:pointer;" onclick="sort(<?=$page?>,'b.DateApprove','1')"><?=$l_approve_date?></a></td>
        </tr>
        <?php 
        if(mysql_num_rows($query)>0){
        	$i=0;
        	while($row=mysql_fetch_array($query)){
        		if ( $i >= $page_start  ) 
				{	
			    	if($row[IDTypeDoc]==7)$document = $l_vacation_form;
				    else if($row[IDTypeDoc]==12)$document = $l_assignment_report;
				    else if($row[IDTypeDoc]==13)$document = $l_purchase_order;
				    else if($row[IDTypeDoc]==14)$document = $l_daily_report;
				    else if($row[IDTypeDoc]==15)$document = $l_business_trip_report;
				    else if($row[IDTypeDoc]==16)$document = $l_weekly_report;
				    else if($row[IDTypeDoc]==17)$document = $l_susqence_payment_request;
			    
			?>
				<tr bgcolor="#ffffff" class="highlighter">
					<td><input type="checkbox"  name="chon" value="<?php echo $row[IDGroupApprove];?>" /></td>
					<td align="center"><?=($i+1)?></td>
					<td ><div  align="left" ><?php echo $document;?></div></td>
					<td ><div  align="left" ><a style="color:blue;" href="view.php?action=<?=$_SESSION['action']?>&id=<?=$row[IDApproveDoc]?>&type=<?=$row[IDTypeDoc]?>&page=<?=$page?>"><?=$row[Tile]?> </a>
						<p style="float:right">
						<?php 
							if($row[IDTypeDoc]==13 || $row[IDTypeDoc]==15 || $row[IDTypeDoc]==17){
								if($row[SumMoney]>0){
									echo "[".number_format($row[SumMoney])."]";
								}else{
									if($row[IDTypeDoc]==15 || $row[IDTypeDoc]==13){
										$s1="select sum(buying_document.total) as tongtien from approvedoc,buying_document where approvedoc.IDApproveDoc=buying_document.document_id and approvedoc.IDApproveDoc='".$row[IDApproveDoc]."' GROUP BY approvedoc.IDApproveDoc";
										$k1=mysql_query($s1);
										while ($r1=mysql_fetch_array($k1)){
											if($r1[tongtien]>0){
												echo " [ ".number_format($r1[tongtien])." ]";
											}
										}
									}else if($row[IDTypeDoc]==17){
										$s1="select sum(ap_advance.money) as tongtien from approvedoc,ap_advance where approvedoc.IDApproveDoc=ap_advance.document_id and approvedoc.IDApproveDoc='".$row[IDApproveDoc]."' GROUP BY approvedoc.IDApproveDoc";
										$k1=mysql_query($s1);
										while ($r1=mysql_fetch_array($k1)){
											if($r1[tongtien]>0){
												echo "[".number_format($r1[tongtien])."]";
											}
										}
									}
								}
							}
						?>
						</p>
					</div></td>
					<td ><?=$row[FullName]?></td>
					<td ><?=$row[Timecreate]?></td>
					<td ><?=$row[DateApprove]?></td>
					
				</tr>
			<?php 	}
			
				$i++; 
				
				if ($i >= $page_end) 
				{ 
				break; 
				} 
        	}
        }
        ?>
        
				
				<?php if ( $number_of_page > 1 ) 
				{ 
					?>
					<tr>
						<td colspan="7" class="bt_td_main">
							<span style="background:#fff; padding:1px; display: inline-block;">
					<?php 
					if ($page==1)
						$p=2;
					else if ($page==$number_of_page)
						$p=$number_of_page-1;
					else $p=$page;
					if($page!=1){?>
						<a onclick="sort(1,'<?=$str?>',0)" ><span class='button_next'><?php echo "<<";?></span> </a>
						<a onclick="sort(<?=($page-1)?>,'<?=$str?>',0)" ><span class='button_next'><?php echo "<";?></span> </a>
					<?php  }
					else{
						//echo "<span class='button_next'><<<</span>"; 
						//echo "<span class='button_next'><<</span>";
					}
					for ( $i = $p-1; $i <= $p+1; $i++ ) {	
							if ($i<=$number_of_page && $i>0)
							
								if ($i==$page){
									echo "<span class='button_next' style='color:#324fa2;font-weight:bold;'>".$i."</span>"; 
								}else{
								?>
									<a onclick="sort(<?=$i?>,'<?=$str?>',0)" ><span class="button_next" style="color: #508e21;">
									<?php 
									echo $i;
									?>
									</span> </a>
									<?php 
								}
							?>
						
					<?php 
							}
						
						if($page!=$number_of_page){ ?>
							<a onclick="sort(<?=($page+1)?>,'<?=$str?>',0)"><span class='button_next'><?php echo ">";?></span> </a>
							<a onclick="sort(<?=($number_of_page)?>,'<?=$str?>',0)" ><span class='button_next'><?php echo ">>";?></span> </a>
						<?php }
						else{
							//echo "<span class='button_next'>>></span> ";
							//echo "<span class='button_next'>>>></span> ";
						}
						?>
						</span>
					</td>
				</tr>
						<?php 
					}
				
					
					?>
																		
			
	</table>
<?php mysql_close($connection);?>